'''from sqlalchemy import create_engine, Column, Integer, String, Table, MetaData
from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy.orm import sessionmaker

USER_NAME = "b"
PASSWORD = "xiaoyu5925"
HOST = "39.96.46.132"
LOCAL_NAME = "b"
engine = create_engine("mysql://"+USER_NAME+":"+PASSWORD+"@"+HOST+"/"+LOCAL_NAME+"?charset=utf8",isolation_level="READ UNCOMMITTED")
Base = declarative_base()
class BTemplate():
    __tablename__ = 'spdier'
    id = Column(Integer, primary_key=True)  # 主键自增
    url = Column(String(100))
    anime_name  = Column(String(100))
    media_id = Column(String(100))
    media_tags = Column(String(100))
    media_info_count_item_play = Column(String(100))
    media_info_count_item_fans = Column(String(100))
    media_info_count_item_review = Column(String(100))
    short_comment = Column(String(200))
    long_comment = Column(String(100))
    score = Column(String(100))
    score_all_people = Column(String(10000))
    order = Column(String(300))


    def __init__(self,url,anime_name,media_id,media_tags,media_info_count_item_play,media_info_count_item_fans,media_info_count_item_review,short_comment,long_comment,score,score_all_people,order):
        self.url=url
        self.anime_name=anime_name
        self.media_id=media_id
        self.media_tags=media_tags
        self.media_info_count_item_play=media_info_count_item_play
        self.media_info_count_item_fans=media_info_count_item_fans
        self.media_info_count_item_review=media_info_count_item_review
        self.short_comment = short_comment
        self.long_comment = long_comment
        self.score = score
        self.score_all_people = score_all_people
        self.order = order
        self.indate=datetime.datetime.now().strftime("%Y-%m-%d %H:%M:%S")
'''